MacWorld 1998 February/Macworld (1998-02).dmg/Inside Macworld/FileMaker Pro 4/Full FM4 Templates/Business/Expenses System/Employee Names

FileMaker Pro Database | 1997-09-14 | 142KB | 801 lines

f4O2EcxglLx8O2huPcWv/zO3h8
/zb5/2LwNv7+jtH+aqicQWrha0Hod3gv40TzhiO8gQGll9RYL5WABbOGSuwTFuJN80fQGVz4mMZ2
IK+GOVzKtqih2gtKSQ1dobroPreETwiPU67yjvGLrk8uARWJ+Qy8z3RnCHuhHl11ojq2muMPQvsM
ZBxJZ+4ld9zpwu/GxHxQpelokPaCRzfe5EJi1aISVmaGBKZG4fuClCRUV1GPijvhgRNmmV12gvW+
ZLRWtzCLBqEW8S6humEP4mQUV7ZXCQWo6YneWcm3rdpaeLG4jYP3gY7w0/vW316q/B28eGyvcu2R
e2+tbdF8d4YepfVLjWuPFX45tiNtuvcVgBTqrKYWMOlV/k6mxDrElXp/QLGwkfUjCy0lzkA/CnL2
DeuzjhZ5/Tw0vjXD1AUPv491BdCkqcl9zz7vWTEITckLNISPIGUv7eKqox4cAPcLapCjVBKwmjT3
HBAM2016AUG95
Pro 3.0
nvoice-processing. You can also add fields and edit value lists to reflect your own products and services.
y-Billing, Invoicing , Sales, Inventory Controlz
10/24/95{
10/26/95
Paul Farrah
Business
-Y    Timecards
Description
This database keeps track of employee hours, and is based on the standard employee
ding a summary field for each time category.
Finance, Payroll, Timez
10/24/95{
10/24/95
Paul Farrah
Business
HBAM3016AUG95
HP DeskJet 540 Printer
nknown
an unexpected TCP/IP error (
AppleTalk is not enabled ( TCP/IP couldn't be initialized (:the manually set TCP/IP address is configured improperly (Jthe TCP/IP address is already in use or an address could not be obtained (
; This file is created and used by FileMaker Pro for TCP/IP access.
; It should contain one IP address or host name per line.
; Lines starting with a semicolon are ignored.
FileMaker Hosts
Local Hosts
Specify Host...:FileMaker host name is limited to 32
Pro 2.0 - 2.1F!
Pro 3.0 - 4.0
CREATED BY
DATE CREATED
DATE MODIFIED
DATE OF BIRTH
DATE OF HIRE
DATE OF NEXT REVIEW
DEPARTMENT
EMERGENCY CONTACT
EMERGENCY PHONE
EMPLOYEE ID
EMPLOYMENT TYPE
FIRST NAME
    FULL NAME
GENDER
     HOME CITY
HOME PHONE
HOME STATE
HOME STREET
HOME ZIP CODE
LAST LAYOUT
.    LAST NAME
MANAGER
MANAGER ID
NOTES
    PAY GRADE
PHONE\EXTENSION
PHOTO
SALARY
SOCIAL SECURITY NUMBER
TITLE
Employee IDB
First NameB
SalaryB
DepartmentB
ManagerB
Pro 2.0 - 2.1F!
Pro 3.0 - 4.0
    USENG.NDX
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
7/29/975
Description
You can use this database file to maintain employee data such as hire date, salary, manager, department, pay grade, and next review date. You can also include personal information.
How to use this solution
Use the phone dialing feature to quickly dial the employee's extension. In an emergency, you can click the telephone icon next to the emergency contact information to call the contact person. You can edit your phone dialing preferences in the Preferences dialog box.
How to B
customize this solution
You can create a layout to print employee identification badges. You can also integrate this database with other databases, such as "Expense Reports" using lookups and relations.
Form View - Job
A    List View
Employee Phone List
Information
Report Menu
A    Pay GradeB
TitleB
Home StreetB
A    Home CityB
Home StateB
Home ZIP CodeB
NotesB
Phone\ExtensionB
Date CreatedB
Date ModifiedB
Social Security NumberB
X1Please enter a number in the form of 000-00-0000.
 ) = 11 )
GenderB
Date of BirthB
Date of HireB
Date of Next ReviewB
Home PhoneB
Employment TypeB
PhotoB
Emergency ContactB
Emergency PhoneB
InfoB
Created ByB
Last LayoutB
/A    Full Name
 & " " &
Manager IDB
Form View - JobB
Form View - Personal
A    List ViewB
Your Own
Buttons
Your Own
Buttont
Recordu
Delete
Recordv
Recordw
Reportsx
View As
Listy
View As
Formz
Close{
Info|
Employment Type}
Social Security No.~
Date of Hire
Next Review
Salary
A    Pay Grade
Phone/Ext.
Department
Title
F    Last Name
First Name
I,Enter Job Position information for Employees
Personal
Information
Position
P    Employees
Expenses File...
Notes
Manager
Manager ID
Line Items File...
Employee Phone ListB
Phone\Ext.P
DepartmentQ
TitleR    Last NameS
First NameT
Your Own
ButtonU
Your Own
ButtonV
RecordW
Delete
RecordX
RecordY
ReportsZ
View As
List[
View As
Form\
Close]
Info^-Click to see more information for an Employee
InformationB
Your Own
Buttonn
Reportso
View As
Listp
View As
Formq
Closer
Infos
Phonet
Departmentu
Titlev    Last Namew
Page ##y
Employee Phone Listz
First Name{
Employee Phone List
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO-Information about the Employee Names solutionP
Info for this Solution
about the Employee Names solutionP
Info for this Solution
Your Own
ReportB
Your Own ReportC
Your Own ReportD
Employee Phone ListE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
Form View - PersonalB
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Your Own
Button{
Your Own
Button|
Record}
Delete
Record~
Record
Reports
View As
View As
Close
Emergency
Phone
Emergency Contact
Gender
G    Birthdate
Phone
ZIP Code
Address
U(Enter Personal Information for Employees
Z    Employees
Expenses File...7
Your Own
Button{
Your Own
Button|
Record}
Delete
Record~
Record
Reports
View As
View As
Close
Emergency
Phone
Emergency Contact
Gender
G    Birthdate
Phone
ZIP Code
Address
U(Enter Personal Information for Employees
Z    Employees
Expenses File...
Line Items File...
Personal
Information
Position
First Name
    Last Name
Phone/Ext.
Title
Department
Notes
Sort by Department
Sort by Last Name
Employee Phone List
Open Script
Dial Extension
Dial Home Phone
Dial Emergency Phone
Sort by Last Name
Sort by Department
Employee Phone List
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Open Script
Dial Extension
Dial Home Phone
Dial Emergency Phone
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E)
Information
A    List View
Report Menu
Open Employee Expenses File
Open Expense Line Items File
Shutdown Script
Open Employee Expenses File
Open Expense Line Items File
Information
    List View
Report Menu
Sort by Department
Sort by Last Name
Employee Phone List
Open Script
Dial Extension
Dial Home Phone
Dial Emergency Phone
Shutdown Script
Sort by Last Name
Sort by Department
Employee Phone List
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
:NAME
FPTHA:HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee expenses.fp3
NAMEA
Employee expenses.fp3
RPTHA
Employee expenses.fp3
SRPTA
emp_exp.fp3
WSPCA C:\CONSULT\ClarisII\v3\qafirst\
;NAME
FPTHA;HARDDISK:CONSULT:ClarisII:v3:qafirst:Expense Line Items.fp3
NAMEA
Expense Line Items.fp3
RPTHA
Expense Line Items.fp3
SRPTA
exp_itms.fp3
WSPCA C:\CONSULT\ClarisII\v3\qafirst\
eRPTH
FPTHAeGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Expenses
MSPCA
NAMEA
Employee Expenses
RPTHA
Employee Expenses
alisVDEF
(LIST
VDEFA(
Managers
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
AD@D@
AD@D@
44444
CCCCC 44444 CCCCC
$42"
@@BA@
bRBBP0
UUUUU
 JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
 *00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
(*)(%,3&
)%+@6)
",30,)%
UUUUUU
wwwwww
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
alisA
Gender ListB
Employment Type ListC
Manager List
FMRLA
Managers
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Courier
Courier New
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
A    Last NameB
First NameB
SalaryB
DepartmentB
ManagerB
nes starting with a semicolon are ignored.
FileMaker Hosts
Local Hosts
Specify Host...:FileMaker host name is limited to 32
fRPTH
FPTHAfGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Expense Line Items
MSPCA
NAMEA
Expense Line Items
RPTHA
Expense Line Items
Grendal
Expense Line Items
FMP3FMP3
Expenses System
fGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Expense Line Items
SCW-InfoMgmt
Kevster (7100/66)
Grendal
Kevin Jundt
Grendal
Employee Expenses
FMP3FMP3
Expenses System
eGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Expenses
SCW-InfoMgmt
Kevster (7100/66)
Grendal
Kevin Jundt
(LIST
LISTA
Female
VDEFA(
(LIST
LISTA*Full Time
Part Time
Contractor
Temporary
VDEFA(
(LIST
VDEFA(